let id1 = args.id;
lib.dbQueryJsonArray(`SELECT 
si.order_sn,
wh.name as wname,
sip.sku,
pd.name as pname,
sip.good_product,
sip.defective_product,
sip.create_time
FROM stock_in si 
LEFT JOIN stock_in_product sip on si.id=sip.parent_stock_in_id 
LEFT JOIN sales_withdraw sw on si.remarks=sw.rma_order_no
LEFT JOIN warehouse wh on si.warehouse=wh.id
LEFT JOIN product pd on sip.product_id=pd.id
WHERE sw.id=? and pd.del_flag=0 and si.del_flag=0 and wh.del_flag=0`,id1);